Data Analyst II
Welcome!
We invite you to explore the award-winning culture, people, rewards and opportunities that make Comerica Bank so special. Make your next career choice a confident one.
Qualifications
Position Qualifications:
• Bachelor's Degree from an accredited university in Computer Science, Engineering, Math, or other relevant technology degrees or High School diploma or GED and 8 years of progressively responsible experience
• 4 years of Technology experience and proficiency
• 3 years of experience leading large, complex/critical technology projects
• 3 years of experience Influencing strategy for large organizations
• 2 years of experience in data structures and data modeling
• 2 years of experience in data visualization techniques experience (Power BI, Tableau)
• 2 years of experience documenting and assisting product owners with creating system/business requirements
• 2 years of experience with Microsoft Office and expanded product lines (Visio, MS Project, SharePoint)
• 2 years of experience in banking or related industries
Preferred Qualifications:
• Proficiency in data profiling, statistical analysis, data analysis, and data standardization / cleansing techniques
• Strong SQL skills with the ability to write sophisticated queriers across large, complex data sets
• Experience using statistical techniques to discover the root cause of data quality issues and recommend remediation options
• Ability to analyze data trends, identify patterns and proactively address potential data quality issues
• Experience with Collibra, Informatica, and Snowflake (Python, R is a plus)
Job Description
Data Analyst II
The Data Analyst II will serve as a member of a Enterprise Data Analytics team providing visualization, analytical and architecture support for complex data systems and documenting data requirements. This person is a key contributor on data initiatives through the delivery of data pipelines, reports, dashboards, and insights derived from multiple data sources / types. They ensure data sourced for pipelines, reports, and dashboards they deliver are of the highest quality while also supporting data preparation requirements for analytics team members. The Data Analyst II serves as a front-line data user that supports manual and automated data quality processes to ensure company data is maintained at a high quality (test case generation). Through this function, the Data Analyst II also recommends methodologies to improve data quality and analytical preparation processes. Additionally, they serve as a source for business / data requirements for strategic data initiatives.
Position Responsibilities:
Delivery Excellence
• Assists in leading a collaborative, dynamic Product planning process prioritizing efforts that align with Comerica and Technology strategies and provide the best value and outcome for the investment.
• While working with the Data Product Management,Data Governance Team and Information Architects, they are responsible for developing structured development plans that drive Product releases from inception through delivery.
• Works with Data Product Management Leadership Data Product Management, Data Governance and Information Architects to decompose the Product Vision and Product Roadmap into themes which captured in the Data Product Backlog.
Reporting
• Delivers complex ad hoc reports and dashboards based on documented business requirements.
• Provides functional oversight to junior team members in the delivery of customized reports and dashboards.
• Maintain data and visualization capabilities of developed data assets to ensure quality and support reuse.
• Oversees the delivery of reporting capabilities as a part of a delivery team executing consultative insights and analysis to business decisionmakers.
• Performs routine quality checks on existing data assets to ensure integrity and recommends solutions to data quality issues.
• Supports the enterprise data strategy by delivering requirements supporting report automation, SLA's and data quality thresholds based on business needs.
Data Wrangling and Modeling
• Manipulates, maps, and integrates data from existing data products, pipelines, and reports to support data value delivery.
• Performs ad hoc data quality checks on pipeline data to support data quality management and issue remediation processes.
• Provides requirements to Architects to support data design requirements for strategic data assets.
• Ensures data integration efforts supporting business requirements conform to established Enterprise and domain data models, as required.
Insight Delivery
• With some oversight, provide business intelligence advice and insights to business stakeholders supporting fact-based decision making.
• Provides ad hoc data pipelines for analysts to support complex insights and analysis.
• Oversees activities of junior team members in the delivery of data visualization and reporting to support insight delivery and advanced analysis.
Communication
• Maintains communication with Data Product Management and Information Architect stakeholders on the Enterprise Data Analytics Team and other lines of business to ensure that there is visibility into the Product's direction, schedule, progress, and operational status.
About Comerica
We know our employees are critical to our overall success and we are dedicated to investing in their future. One of the ways we do this is to offer a comprehensive Total Rewards package designed to recognize and reward individual performance, as well support health, well-being, development and security for our colleagues and their family. Total Rewards consists of cash compensation, development and flexible benefit programs designed to meet individual needs today and in the future. Your salary will be commensurate with your work experience and our programs are reviewed regularly to ensure each remain competitive. We are proud to offer benefits such as health and welfare programs, strong retirement benefits, and generous paid time off programs. You and your eligible family members, including domestic partners and their children, can participate in medical, dental, and vision benefits, 401(k) and pension, income protection benefits such as life insurance, AD D, and supplemental health programs to offset unexpected health care expenses. We also have a variety of time off programs for things like vacation, sick time, disability, and parental leave. Eligibility for some programs varies based on employment status and tenure.
Upon offer, Comerica conducts a comprehensive background and fingerprint check.
NMLS certification requirement: where applicable, a favorable background check screening, credit check, fingerprint check, and NMLS certification is required in accordance with the SAFE Act.
Comerica Incorporated (NYSE: CMA) is a financial services company headquartered in Dallas, Texas, and strategically aligned into three major business segments; the Commercial Bank, the Retail Bank, and Wealth Management. Comerica's colleagues focus on relationships, and helping people and businesses be successful. In addition to Texas, Comerica Bank locations can be found in Arizona, California, Florida and Michigan, with select businesses operating in several other states, as well as in Canada and Mexico.
Comerica is proud to be an Equal Opportunity Employer - veterans/individuals with disabilities, committed to workplace diversity.
